# -*- coding:utf-8 -*-
"""
@file: pandas_con_mysql.py 
@time: 2019/07/14
@author: 
descript:
"""
import pymysql
import pandas as pd

con = pymysql.connect(host="127.0.0.1", user="root", password="root", db="yxl_test")
# 读取sql
data_sql = pd.read_sql("select * from danzhu_chan_liang d where d.six_year_ky>60", con)
print(data_sql)
